<html lang="es">
<head>
<meta charset="UTF-8">
<link rel="shortcut icon" type="image/x-icon" href="style/images/favicon.png" />
<link rel="stylesheet" type="text/css" href="style.css" media="all" />
<link rel="stylesheet" type="text/css" href="style/color/red.css" media="all" />
<link rel="stylesheet" type="text/css" media="screen" href="style/css/prettyPhoto.css"  />
<link rel="stylesheet" type="text/css" href="style/type/museo.css" media="all" />
<link rel="stylesheet" type="text/css" href="style/type/ptsans.css" media="all" />
<link rel="stylesheet" type="text/css" href="style/type/charis.css" media="all" />
<!--[if IE 7]>
<link rel="stylesheet" type="text/css" href="style/css/ie7.css" media="all" />
<![endif]-->
<!--[if IE 8]>
<link rel="stylesheet" type="text/css" href="style/css/ie8.css" media="all" />
<![endif]-->
<!--[if IE 9]>
<link rel="stylesheet" type="text/css" href="style/css/ie9.css" media="all" />
<![endif]-->
<script type="text/javascript" src="style/js/jquery-1.6.2.min.js"></script>
<script type="text/javascript" src="style/js/ddsmoothmenu.js"></script>
<script type="text/javascript" src="style/js/transify.js"></script>
<script type="text/javascript" src="style/js/jquery.prettyPhoto.js"></script>
<script type="text/javascript" src="style/js/jquery.superbgimage.min.js"></script>
<script type="text/javascript" src="style/js/jquery.slickforms.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($){
	$('.forms').dcSlickForms();
});
</script>
</head>
<body>
<!-- Begin Wrapper -->
<div id="wrapper">
  <div id="header">
    <div class="logo opacity">AutoGuayana, C.A</div>
  </div>
  <div class="clear"></div>
  <!-- Begin Menu -->
  <div id="menu" class="menu opacity">
    <ul>
      <li><a href="">Cerrar Sesión</a></li>
    </ul>
    <br style="clear: left" />
  </div>
  <!-- End Menu --> 
  
  <!-- Begin Container -->
  <div id="container" class="opacity"> 
    <!-- Begin Content -->
    <div class="content">     
        <h2>Editar Vehiculo</h2>
        <form class="forms" method="POST" action="Guardado/editarVeh.php">
                <fieldset>
                    <ol>
                        <li class="form-row text-input-row">
                            <label><strong>ID Del Vehiculo a Editar</strong></label>
                            <input type="number" name="idVehiculo" placeholder="001" class="text-input required " required/>
                        </li>
                        <br/>
                        <li class="form-row text-input-row">
                            <label><strong>Nuevo Modelo</strong></label>
                            <input type="text" name="modelo" placeholder="Emotion, Evolution ..." class="text-input " />
                        </li>  
                        <li class="form-row text-input-row">
                            <label><strong>Nueva Marca</strong></label>
                            <input type="text" name="marca" placeholder="BMW,Chevrolet...." class="text-input " />
                        </li>
                        <li class="form-row text-input-row">
                            <label><strong>Nuevo Nro Cilindros</strong></label>
                            <input type="number" name="cilindros" placeholder="2, 4 ..." class="text-input " />
                        </li>
                        <li class="form-row text-input-row">
                            <label><strong>Nuevo Nro. Puertas</strong></label>
                            <input type="number" name="puertas" placeholder="3, 5 .." class="text-input " />
                        </li>  
                        <li class="form-row text-input-row">
                            <label><strong>Nuevo Peso (Kg)</strong></label>
                            <input type="number" name="peso" placeholder="1800" class="text-input " />
                        </li>                     
                         
                        <li class="form-row text-input-row">
                            <label><strong>Nueva Capacidad</strong></label>
                            <input type="number" name="capacidad" placeholder="2, 4, 6 .." class="text-input " />
                        </li>  
                          <li class="form-row text-input-row">
                            <label><strong>Nuevo Seguro</strong></label>
                            <input type="text" name="seguro" placeholder="Nombre seguro" class="text-input " />
                        </li>  
                        <label>
                               <strong>Color</strong>
                             </label>
                             <select class="form-control" name='color'>
                               
     <?php

	$host	= "localhost";
	$db	= "autoguayanaBD";
	$user	= "postgres";
	$password = "12345";
        $port = "5432";

	// Abrir la Conexión
        $datos = "host=$host port=$port dbname=$db user=$user password=$password";
        $conex= pg_connect($datos)  or die("Error en conexion".pg_last_error());
        
    $color=0;
    
    $desven2 = "SELECT co.idcolor,
                       co.descp
                 FROM color as co
                 WHERE idcolor<>$color";
    
    $query1 = pg_query($conex,$desven2) or die('Consulta fallida: ' . pg_last_error());
   while(  $linea = pg_fetch_array($query1, null, PGSQL_ASSOC)){
       
      
    
?>
                             
                          
                                     <option value='<?php echo $linea['idcolor'] ?>'><?php echo $linea['descp'] ?></option>
                                     
                                
                    <?php
                        
   }
    pg_close($conex);
                        ?> 
                                 
                             </select>
                        </br></br>
                        <li class="form-row text-input-row">
                            <label><strong>Nuevo Precio (Bs)</strong></label>
                            <input type="number" name="precio" placeholder="380000000" class="text-input " />
                        </li>  
                     <button type="submit" class="btn-submit" name="enviar">
                                Agregar
                        </button>
                    </ol>
                </fieldset>
            </form>
          <div class="response"></div>
    </div>
    <!-- End Content -->  
    
      <!-- Begin Sidebar -->
    <div class="sidebar">
      <div class="sidebar-box">
        <div class="cat-list">
          <ul>
            <h4>Vehículos</h4>
            <li><a href="agregarVehiculo.php">Agregar</a></li>
            <li><a href="modficarVeh.php">Modificar características</a></li>            
            <h4>Clientes</h4>
            <li><a href="agregarCliente.php">Agregar</a></li>
            <li><a href="listaClientes.php">Lista de clientes</a></li>
            <h4>Ventas</h4>
            <li><a href="ListaVentas.php">Lista de ventas</a></li>
            <h4>Departamento</h4>
            <li><a href="crearDepartamento.php">Agregar</a></li>
            <li><a href="editarDepartamentos.php">Modificar elementos</a></li>
            <li><a href="listaDepartamentos.php#">Lista de departamentos</a></li>
            <h4>Empleados</h4>
            <li><a href="AgregarVendedor.php">Agregar</a></li> 
            <li><a href="editarEmpleado.php">Modificar datos</a></li>
            <li><a href="reporteDepartamento.php">Reporte</a></li>
            <h4>Facturas</h4>
            <li><a href="listaFactura.php">Lista de facturas</a></li>   
            <h4>Accesorios</h4>
            <li><a href="AgregarAcc.php">Agregar Accesorio</a></li> 
            <li><a href="editarAcce.php">Editar Accesorio</a></li> 
          </ul>
        </div>
      </div>      
    </div>
    <!-- End Sidebar --> 
   </div>
  <!-- End Container -->
  
  <div id="copyright" class="opacity">
    <p>AutoGuayana, C.A. UCAB-Guayana</p>
  </div>
</div>
<!-- End Wrapper --> 

<script type="text/javascript" src="style/js/scripts.js"></script>
</body>
</html>
